package com.ssish.saas.eccs.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class RsvamtTrackingExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public RsvamtTrackingExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andClaimsIdIsNull() {
            addCriterion("CLAIMS_ID is null");
            return (Criteria) this;
        }

        public Criteria andClaimsIdIsNotNull() {
            addCriterion("CLAIMS_ID is not null");
            return (Criteria) this;
        }

        public Criteria andClaimsIdEqualTo(Integer value) {
            addCriterion("CLAIMS_ID =", value, "claimsId");
            return (Criteria) this;
        }

        public Criteria andClaimsIdNotEqualTo(Integer value) {
            addCriterion("CLAIMS_ID <>", value, "claimsId");
            return (Criteria) this;
        }

        public Criteria andClaimsIdGreaterThan(Integer value) {
            addCriterion("CLAIMS_ID >", value, "claimsId");
            return (Criteria) this;
        }

        public Criteria andClaimsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("CLAIMS_ID >=", value, "claimsId");
            return (Criteria) this;
        }

        public Criteria andClaimsIdLessThan(Integer value) {
            addCriterion("CLAIMS_ID <", value, "claimsId");
            return (Criteria) this;
        }

        public Criteria andClaimsIdLessThanOrEqualTo(Integer value) {
            addCriterion("CLAIMS_ID <=", value, "claimsId");
            return (Criteria) this;
        }

        public Criteria andClaimsIdIn(List<Integer> values) {
            addCriterion("CLAIMS_ID in", values, "claimsId");
            return (Criteria) this;
        }

        public Criteria andClaimsIdNotIn(List<Integer> values) {
            addCriterion("CLAIMS_ID not in", values, "claimsId");
            return (Criteria) this;
        }

        public Criteria andClaimsIdBetween(Integer value1, Integer value2) {
            addCriterion("CLAIMS_ID between", value1, value2, "claimsId");
            return (Criteria) this;
        }

        public Criteria andClaimsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("CLAIMS_ID not between", value1, value2, "claimsId");
            return (Criteria) this;
        }

        public Criteria andTransactionDateIsNull() {
            addCriterion("TRANSACTION_DATE is null");
            return (Criteria) this;
        }

        public Criteria andTransactionDateIsNotNull() {
            addCriterion("TRANSACTION_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andTransactionDateEqualTo(Date value) {
            addCriterion("TRANSACTION_DATE =", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateNotEqualTo(Date value) {
            addCriterion("TRANSACTION_DATE <>", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateGreaterThan(Date value) {
            addCriterion("TRANSACTION_DATE >", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateGreaterThanOrEqualTo(Date value) {
            addCriterion("TRANSACTION_DATE >=", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateLessThan(Date value) {
            addCriterion("TRANSACTION_DATE <", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateLessThanOrEqualTo(Date value) {
            addCriterion("TRANSACTION_DATE <=", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateIn(List<Date> values) {
            addCriterion("TRANSACTION_DATE in", values, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateNotIn(List<Date> values) {
            addCriterion("TRANSACTION_DATE not in", values, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateBetween(Date value1, Date value2) {
            addCriterion("TRANSACTION_DATE between", value1, value2, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateNotBetween(Date value1, Date value2) {
            addCriterion("TRANSACTION_DATE not between", value1, value2, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusIsNull() {
            addCriterion("CLAIMS_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusIsNotNull() {
            addCriterion("CLAIMS_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusEqualTo(String value) {
            addCriterion("CLAIMS_STATUS =", value, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusNotEqualTo(String value) {
            addCriterion("CLAIMS_STATUS <>", value, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusGreaterThan(String value) {
            addCriterion("CLAIMS_STATUS >", value, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusGreaterThanOrEqualTo(String value) {
            addCriterion("CLAIMS_STATUS >=", value, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusLessThan(String value) {
            addCriterion("CLAIMS_STATUS <", value, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusLessThanOrEqualTo(String value) {
            addCriterion("CLAIMS_STATUS <=", value, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusLike(String value) {
            addCriterion("CLAIMS_STATUS like", value, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusNotLike(String value) {
            addCriterion("CLAIMS_STATUS not like", value, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusIn(List<String> values) {
            addCriterion("CLAIMS_STATUS in", values, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusNotIn(List<String> values) {
            addCriterion("CLAIMS_STATUS not in", values, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusBetween(String value1, String value2) {
            addCriterion("CLAIMS_STATUS between", value1, value2, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimsStatusNotBetween(String value1, String value2) {
            addCriterion("CLAIMS_STATUS not between", value1, value2, "claimsStatus");
            return (Criteria) this;
        }

        public Criteria andClaimNoIsNull() {
            addCriterion("CLAIM_NO is null");
            return (Criteria) this;
        }

        public Criteria andClaimNoIsNotNull() {
            addCriterion("CLAIM_NO is not null");
            return (Criteria) this;
        }

        public Criteria andClaimNoEqualTo(String value) {
            addCriterion("CLAIM_NO =", value, "claimNo");
            return (Criteria) this;
        }

        public Criteria andClaimNoNotEqualTo(String value) {
            addCriterion("CLAIM_NO <>", value, "claimNo");
            return (Criteria) this;
        }

        public Criteria andClaimNoGreaterThan(String value) {
            addCriterion("CLAIM_NO >", value, "claimNo");
            return (Criteria) this;
        }

        public Criteria andClaimNoGreaterThanOrEqualTo(String value) {
            addCriterion("CLAIM_NO >=", value, "claimNo");
            return (Criteria) this;
        }

        public Criteria andClaimNoLessThan(String value) {
            addCriterion("CLAIM_NO <", value, "claimNo");
            return (Criteria) this;
        }

        public Criteria andClaimNoLessThanOrEqualTo(String value) {
            addCriterion("CLAIM_NO <=", value, "claimNo");
            return (Criteria) this;
        }

        public Criteria andClaimNoLike(String value) {
            addCriterion("CLAIM_NO like", value, "claimNo");
            return (Criteria) this;
        }

        public Criteria andClaimNoNotLike(String value) {
            addCriterion("CLAIM_NO not like", value, "claimNo");
            return (Criteria) this;
        }

        public Criteria andClaimNoIn(List<String> values) {
            addCriterion("CLAIM_NO in", values, "claimNo");
            return (Criteria) this;
        }

        public Criteria andClaimNoNotIn(List<String> values) {
            addCriterion("CLAIM_NO not in", values, "claimNo");
            return (Criteria) this;
        }

        public Criteria andClaimNoBetween(String value1, String value2) {
            addCriterion("CLAIM_NO between", value1, value2, "claimNo");
            return (Criteria) this;
        }

        public Criteria andClaimNoNotBetween(String value1, String value2) {
            addCriterion("CLAIM_NO not between", value1, value2, "claimNo");
            return (Criteria) this;
        }

        public Criteria andCardNoIsNull() {
            addCriterion("CARD_NO is null");
            return (Criteria) this;
        }

        public Criteria andCardNoIsNotNull() {
            addCriterion("CARD_NO is not null");
            return (Criteria) this;
        }

        public Criteria andCardNoEqualTo(BigDecimal value) {
            addCriterion("CARD_NO =", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotEqualTo(BigDecimal value) {
            addCriterion("CARD_NO <>", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoGreaterThan(BigDecimal value) {
            addCriterion("CARD_NO >", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CARD_NO >=", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoLessThan(BigDecimal value) {
            addCriterion("CARD_NO <", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CARD_NO <=", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoIn(List<BigDecimal> values) {
            addCriterion("CARD_NO in", values, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotIn(List<BigDecimal> values) {
            addCriterion("CARD_NO not in", values, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARD_NO between", value1, value2, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARD_NO not between", value1, value2, "cardNo");
            return (Criteria) this;
        }

        public Criteria andReservedAmtIsNull() {
            addCriterion("RESERVED_AMT is null");
            return (Criteria) this;
        }

        public Criteria andReservedAmtIsNotNull() {
            addCriterion("RESERVED_AMT is not null");
            return (Criteria) this;
        }

        public Criteria andReservedAmtEqualTo(BigDecimal value) {
            addCriterion("RESERVED_AMT =", value, "reservedAmt");
            return (Criteria) this;
        }

        public Criteria andReservedAmtNotEqualTo(BigDecimal value) {
            addCriterion("RESERVED_AMT <>", value, "reservedAmt");
            return (Criteria) this;
        }

        public Criteria andReservedAmtGreaterThan(BigDecimal value) {
            addCriterion("RESERVED_AMT >", value, "reservedAmt");
            return (Criteria) this;
        }

        public Criteria andReservedAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RESERVED_AMT >=", value, "reservedAmt");
            return (Criteria) this;
        }

        public Criteria andReservedAmtLessThan(BigDecimal value) {
            addCriterion("RESERVED_AMT <", value, "reservedAmt");
            return (Criteria) this;
        }

        public Criteria andReservedAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RESERVED_AMT <=", value, "reservedAmt");
            return (Criteria) this;
        }

        public Criteria andReservedAmtIn(List<BigDecimal> values) {
            addCriterion("RESERVED_AMT in", values, "reservedAmt");
            return (Criteria) this;
        }

        public Criteria andReservedAmtNotIn(List<BigDecimal> values) {
            addCriterion("RESERVED_AMT not in", values, "reservedAmt");
            return (Criteria) this;
        }

        public Criteria andReservedAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RESERVED_AMT between", value1, value2, "reservedAmt");
            return (Criteria) this;
        }

        public Criteria andReservedAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RESERVED_AMT not between", value1, value2, "reservedAmt");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksIsNull() {
            addCriterion("PAYOR_REMARKS is null");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksIsNotNull() {
            addCriterion("PAYOR_REMARKS is not null");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksEqualTo(String value) {
            addCriterion("PAYOR_REMARKS =", value, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksNotEqualTo(String value) {
            addCriterion("PAYOR_REMARKS <>", value, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksGreaterThan(String value) {
            addCriterion("PAYOR_REMARKS >", value, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("PAYOR_REMARKS >=", value, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksLessThan(String value) {
            addCriterion("PAYOR_REMARKS <", value, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksLessThanOrEqualTo(String value) {
            addCriterion("PAYOR_REMARKS <=", value, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksLike(String value) {
            addCriterion("PAYOR_REMARKS like", value, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksNotLike(String value) {
            addCriterion("PAYOR_REMARKS not like", value, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksIn(List<String> values) {
            addCriterion("PAYOR_REMARKS in", values, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksNotIn(List<String> values) {
            addCriterion("PAYOR_REMARKS not in", values, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksBetween(String value1, String value2) {
            addCriterion("PAYOR_REMARKS between", value1, value2, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksNotBetween(String value1, String value2) {
            addCriterion("PAYOR_REMARKS not between", value1, value2, "payorRemarks");
            return (Criteria) this;
        }

        public Criteria andApprovedDateIsNull() {
            addCriterion("APPROVED_DATE is null");
            return (Criteria) this;
        }

        public Criteria andApprovedDateIsNotNull() {
            addCriterion("APPROVED_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andApprovedDateEqualTo(Date value) {
            addCriterion("APPROVED_DATE =", value, "approvedDate");
            return (Criteria) this;
        }

        public Criteria andApprovedDateNotEqualTo(Date value) {
            addCriterion("APPROVED_DATE <>", value, "approvedDate");
            return (Criteria) this;
        }

        public Criteria andApprovedDateGreaterThan(Date value) {
            addCriterion("APPROVED_DATE >", value, "approvedDate");
            return (Criteria) this;
        }

        public Criteria andApprovedDateGreaterThanOrEqualTo(Date value) {
            addCriterion("APPROVED_DATE >=", value, "approvedDate");
            return (Criteria) this;
        }

        public Criteria andApprovedDateLessThan(Date value) {
            addCriterion("APPROVED_DATE <", value, "approvedDate");
            return (Criteria) this;
        }

        public Criteria andApprovedDateLessThanOrEqualTo(Date value) {
            addCriterion("APPROVED_DATE <=", value, "approvedDate");
            return (Criteria) this;
        }

        public Criteria andApprovedDateIn(List<Date> values) {
            addCriterion("APPROVED_DATE in", values, "approvedDate");
            return (Criteria) this;
        }

        public Criteria andApprovedDateNotIn(List<Date> values) {
            addCriterion("APPROVED_DATE not in", values, "approvedDate");
            return (Criteria) this;
        }

        public Criteria andApprovedDateBetween(Date value1, Date value2) {
            addCriterion("APPROVED_DATE between", value1, value2, "approvedDate");
            return (Criteria) this;
        }

        public Criteria andApprovedDateNotBetween(Date value1, Date value2) {
            addCriterion("APPROVED_DATE not between", value1, value2, "approvedDate");
            return (Criteria) this;
        }

        public Criteria andApprovedByIsNull() {
            addCriterion("APPROVED_BY is null");
            return (Criteria) this;
        }

        public Criteria andApprovedByIsNotNull() {
            addCriterion("APPROVED_BY is not null");
            return (Criteria) this;
        }

        public Criteria andApprovedByEqualTo(String value) {
            addCriterion("APPROVED_BY =", value, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andApprovedByNotEqualTo(String value) {
            addCriterion("APPROVED_BY <>", value, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andApprovedByGreaterThan(String value) {
            addCriterion("APPROVED_BY >", value, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andApprovedByGreaterThanOrEqualTo(String value) {
            addCriterion("APPROVED_BY >=", value, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andApprovedByLessThan(String value) {
            addCriterion("APPROVED_BY <", value, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andApprovedByLessThanOrEqualTo(String value) {
            addCriterion("APPROVED_BY <=", value, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andApprovedByLike(String value) {
            addCriterion("APPROVED_BY like", value, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andApprovedByNotLike(String value) {
            addCriterion("APPROVED_BY not like", value, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andApprovedByIn(List<String> values) {
            addCriterion("APPROVED_BY in", values, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andApprovedByNotIn(List<String> values) {
            addCriterion("APPROVED_BY not in", values, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andApprovedByBetween(String value1, String value2) {
            addCriterion("APPROVED_BY between", value1, value2, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andApprovedByNotBetween(String value1, String value2) {
            addCriterion("APPROVED_BY not between", value1, value2, "approvedBy");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmIsNull() {
            addCriterion("PRINT_CONFIRM is null");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmIsNotNull() {
            addCriterion("PRINT_CONFIRM is not null");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmEqualTo(String value) {
            addCriterion("PRINT_CONFIRM =", value, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmNotEqualTo(String value) {
            addCriterion("PRINT_CONFIRM <>", value, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmGreaterThan(String value) {
            addCriterion("PRINT_CONFIRM >", value, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmGreaterThanOrEqualTo(String value) {
            addCriterion("PRINT_CONFIRM >=", value, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmLessThan(String value) {
            addCriterion("PRINT_CONFIRM <", value, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmLessThanOrEqualTo(String value) {
            addCriterion("PRINT_CONFIRM <=", value, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmLike(String value) {
            addCriterion("PRINT_CONFIRM like", value, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmNotLike(String value) {
            addCriterion("PRINT_CONFIRM not like", value, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmIn(List<String> values) {
            addCriterion("PRINT_CONFIRM in", values, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmNotIn(List<String> values) {
            addCriterion("PRINT_CONFIRM not in", values, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmBetween(String value1, String value2) {
            addCriterion("PRINT_CONFIRM between", value1, value2, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPrintConfirmNotBetween(String value1, String value2) {
            addCriterion("PRINT_CONFIRM not between", value1, value2, "printConfirm");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdIsNull() {
            addCriterion("PHYSICIAN_ID is null");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdIsNotNull() {
            addCriterion("PHYSICIAN_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdEqualTo(String value) {
            addCriterion("PHYSICIAN_ID =", value, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdNotEqualTo(String value) {
            addCriterion("PHYSICIAN_ID <>", value, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdGreaterThan(String value) {
            addCriterion("PHYSICIAN_ID >", value, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdGreaterThanOrEqualTo(String value) {
            addCriterion("PHYSICIAN_ID >=", value, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdLessThan(String value) {
            addCriterion("PHYSICIAN_ID <", value, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdLessThanOrEqualTo(String value) {
            addCriterion("PHYSICIAN_ID <=", value, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdLike(String value) {
            addCriterion("PHYSICIAN_ID like", value, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdNotLike(String value) {
            addCriterion("PHYSICIAN_ID not like", value, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdIn(List<String> values) {
            addCriterion("PHYSICIAN_ID in", values, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdNotIn(List<String> values) {
            addCriterion("PHYSICIAN_ID not in", values, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdBetween(String value1, String value2) {
            addCriterion("PHYSICIAN_ID between", value1, value2, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPhysicianIdNotBetween(String value1, String value2) {
            addCriterion("PHYSICIAN_ID not between", value1, value2, "physicianId");
            return (Criteria) this;
        }

        public Criteria andPrintedDateIsNull() {
            addCriterion("PRINTED_DATE is null");
            return (Criteria) this;
        }

        public Criteria andPrintedDateIsNotNull() {
            addCriterion("PRINTED_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andPrintedDateEqualTo(Date value) {
            addCriterion("PRINTED_DATE =", value, "printedDate");
            return (Criteria) this;
        }

        public Criteria andPrintedDateNotEqualTo(Date value) {
            addCriterion("PRINTED_DATE <>", value, "printedDate");
            return (Criteria) this;
        }

        public Criteria andPrintedDateGreaterThan(Date value) {
            addCriterion("PRINTED_DATE >", value, "printedDate");
            return (Criteria) this;
        }

        public Criteria andPrintedDateGreaterThanOrEqualTo(Date value) {
            addCriterion("PRINTED_DATE >=", value, "printedDate");
            return (Criteria) this;
        }

        public Criteria andPrintedDateLessThan(Date value) {
            addCriterion("PRINTED_DATE <", value, "printedDate");
            return (Criteria) this;
        }

        public Criteria andPrintedDateLessThanOrEqualTo(Date value) {
            addCriterion("PRINTED_DATE <=", value, "printedDate");
            return (Criteria) this;
        }

        public Criteria andPrintedDateIn(List<Date> values) {
            addCriterion("PRINTED_DATE in", values, "printedDate");
            return (Criteria) this;
        }

        public Criteria andPrintedDateNotIn(List<Date> values) {
            addCriterion("PRINTED_DATE not in", values, "printedDate");
            return (Criteria) this;
        }

        public Criteria andPrintedDateBetween(Date value1, Date value2) {
            addCriterion("PRINTED_DATE between", value1, value2, "printedDate");
            return (Criteria) this;
        }

        public Criteria andPrintedDateNotBetween(Date value1, Date value2) {
            addCriterion("PRINTED_DATE not between", value1, value2, "printedDate");
            return (Criteria) this;
        }

        public Criteria andPrintedByIsNull() {
            addCriterion("PRINTED_BY is null");
            return (Criteria) this;
        }

        public Criteria andPrintedByIsNotNull() {
            addCriterion("PRINTED_BY is not null");
            return (Criteria) this;
        }

        public Criteria andPrintedByEqualTo(String value) {
            addCriterion("PRINTED_BY =", value, "printedBy");
            return (Criteria) this;
        }

        public Criteria andPrintedByNotEqualTo(String value) {
            addCriterion("PRINTED_BY <>", value, "printedBy");
            return (Criteria) this;
        }

        public Criteria andPrintedByGreaterThan(String value) {
            addCriterion("PRINTED_BY >", value, "printedBy");
            return (Criteria) this;
        }

        public Criteria andPrintedByGreaterThanOrEqualTo(String value) {
            addCriterion("PRINTED_BY >=", value, "printedBy");
            return (Criteria) this;
        }

        public Criteria andPrintedByLessThan(String value) {
            addCriterion("PRINTED_BY <", value, "printedBy");
            return (Criteria) this;
        }

        public Criteria andPrintedByLessThanOrEqualTo(String value) {
            addCriterion("PRINTED_BY <=", value, "printedBy");
            return (Criteria) this;
        }

        public Criteria andPrintedByLike(String value) {
            addCriterion("PRINTED_BY like", value, "printedBy");
            return (Criteria) this;
        }

        public Criteria andPrintedByNotLike(String value) {
            addCriterion("PRINTED_BY not like", value, "printedBy");
            return (Criteria) this;
        }

        public Criteria andPrintedByIn(List<String> values) {
            addCriterion("PRINTED_BY in", values, "printedBy");
            return (Criteria) this;
        }

        public Criteria andPrintedByNotIn(List<String> values) {
            addCriterion("PRINTED_BY not in", values, "printedBy");
            return (Criteria) this;
        }

        public Criteria andPrintedByBetween(String value1, String value2) {
            addCriterion("PRINTED_BY between", value1, value2, "printedBy");
            return (Criteria) this;
        }

        public Criteria andPrintedByNotBetween(String value1, String value2) {
            addCriterion("PRINTED_BY not between", value1, value2, "printedBy");
            return (Criteria) this;
        }

        public Criteria andAttentionToIsNull() {
            addCriterion("ATTENTION_TO is null");
            return (Criteria) this;
        }

        public Criteria andAttentionToIsNotNull() {
            addCriterion("ATTENTION_TO is not null");
            return (Criteria) this;
        }

        public Criteria andAttentionToEqualTo(String value) {
            addCriterion("ATTENTION_TO =", value, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andAttentionToNotEqualTo(String value) {
            addCriterion("ATTENTION_TO <>", value, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andAttentionToGreaterThan(String value) {
            addCriterion("ATTENTION_TO >", value, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andAttentionToGreaterThanOrEqualTo(String value) {
            addCriterion("ATTENTION_TO >=", value, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andAttentionToLessThan(String value) {
            addCriterion("ATTENTION_TO <", value, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andAttentionToLessThanOrEqualTo(String value) {
            addCriterion("ATTENTION_TO <=", value, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andAttentionToLike(String value) {
            addCriterion("ATTENTION_TO like", value, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andAttentionToNotLike(String value) {
            addCriterion("ATTENTION_TO not like", value, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andAttentionToIn(List<String> values) {
            addCriterion("ATTENTION_TO in", values, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andAttentionToNotIn(List<String> values) {
            addCriterion("ATTENTION_TO not in", values, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andAttentionToBetween(String value1, String value2) {
            addCriterion("ATTENTION_TO between", value1, value2, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andAttentionToNotBetween(String value1, String value2) {
            addCriterion("ATTENTION_TO not between", value1, value2, "attentionTo");
            return (Criteria) this;
        }

        public Criteria andFaxNoIsNull() {
            addCriterion("FAX_NO is null");
            return (Criteria) this;
        }

        public Criteria andFaxNoIsNotNull() {
            addCriterion("FAX_NO is not null");
            return (Criteria) this;
        }

        public Criteria andFaxNoEqualTo(String value) {
            addCriterion("FAX_NO =", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotEqualTo(String value) {
            addCriterion("FAX_NO <>", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoGreaterThan(String value) {
            addCriterion("FAX_NO >", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoGreaterThanOrEqualTo(String value) {
            addCriterion("FAX_NO >=", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoLessThan(String value) {
            addCriterion("FAX_NO <", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoLessThanOrEqualTo(String value) {
            addCriterion("FAX_NO <=", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoLike(String value) {
            addCriterion("FAX_NO like", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotLike(String value) {
            addCriterion("FAX_NO not like", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoIn(List<String> values) {
            addCriterion("FAX_NO in", values, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotIn(List<String> values) {
            addCriterion("FAX_NO not in", values, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoBetween(String value1, String value2) {
            addCriterion("FAX_NO between", value1, value2, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotBetween(String value1, String value2) {
            addCriterion("FAX_NO not between", value1, value2, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxDateIsNull() {
            addCriterion("FAX_DATE is null");
            return (Criteria) this;
        }

        public Criteria andFaxDateIsNotNull() {
            addCriterion("FAX_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andFaxDateEqualTo(Date value) {
            addCriterion("FAX_DATE =", value, "faxDate");
            return (Criteria) this;
        }

        public Criteria andFaxDateNotEqualTo(Date value) {
            addCriterion("FAX_DATE <>", value, "faxDate");
            return (Criteria) this;
        }

        public Criteria andFaxDateGreaterThan(Date value) {
            addCriterion("FAX_DATE >", value, "faxDate");
            return (Criteria) this;
        }

        public Criteria andFaxDateGreaterThanOrEqualTo(Date value) {
            addCriterion("FAX_DATE >=", value, "faxDate");
            return (Criteria) this;
        }

        public Criteria andFaxDateLessThan(Date value) {
            addCriterion("FAX_DATE <", value, "faxDate");
            return (Criteria) this;
        }

        public Criteria andFaxDateLessThanOrEqualTo(Date value) {
            addCriterion("FAX_DATE <=", value, "faxDate");
            return (Criteria) this;
        }

        public Criteria andFaxDateIn(List<Date> values) {
            addCriterion("FAX_DATE in", values, "faxDate");
            return (Criteria) this;
        }

        public Criteria andFaxDateNotIn(List<Date> values) {
            addCriterion("FAX_DATE not in", values, "faxDate");
            return (Criteria) this;
        }

        public Criteria andFaxDateBetween(Date value1, Date value2) {
            addCriterion("FAX_DATE between", value1, value2, "faxDate");
            return (Criteria) this;
        }

        public Criteria andFaxDateNotBetween(Date value1, Date value2) {
            addCriterion("FAX_DATE not between", value1, value2, "faxDate");
            return (Criteria) this;
        }

        public Criteria andFaxStatusIsNull() {
            addCriterion("FAX_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andFaxStatusIsNotNull() {
            addCriterion("FAX_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andFaxStatusEqualTo(String value) {
            addCriterion("FAX_STATUS =", value, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andFaxStatusNotEqualTo(String value) {
            addCriterion("FAX_STATUS <>", value, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andFaxStatusGreaterThan(String value) {
            addCriterion("FAX_STATUS >", value, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andFaxStatusGreaterThanOrEqualTo(String value) {
            addCriterion("FAX_STATUS >=", value, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andFaxStatusLessThan(String value) {
            addCriterion("FAX_STATUS <", value, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andFaxStatusLessThanOrEqualTo(String value) {
            addCriterion("FAX_STATUS <=", value, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andFaxStatusLike(String value) {
            addCriterion("FAX_STATUS like", value, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andFaxStatusNotLike(String value) {
            addCriterion("FAX_STATUS not like", value, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andFaxStatusIn(List<String> values) {
            addCriterion("FAX_STATUS in", values, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andFaxStatusNotIn(List<String> values) {
            addCriterion("FAX_STATUS not in", values, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andFaxStatusBetween(String value1, String value2) {
            addCriterion("FAX_STATUS between", value1, value2, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andFaxStatusNotBetween(String value1, String value2) {
            addCriterion("FAX_STATUS not between", value1, value2, "faxStatus");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIsNull() {
            addCriterion("PAYOR_CODE is null");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIsNotNull() {
            addCriterion("PAYOR_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andPayorCodeEqualTo(String value) {
            addCriterion("PAYOR_CODE =", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotEqualTo(String value) {
            addCriterion("PAYOR_CODE <>", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeGreaterThan(String value) {
            addCriterion("PAYOR_CODE >", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYOR_CODE >=", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLessThan(String value) {
            addCriterion("PAYOR_CODE <", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLessThanOrEqualTo(String value) {
            addCriterion("PAYOR_CODE <=", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLike(String value) {
            addCriterion("PAYOR_CODE like", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotLike(String value) {
            addCriterion("PAYOR_CODE not like", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIn(List<String> values) {
            addCriterion("PAYOR_CODE in", values, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotIn(List<String> values) {
            addCriterion("PAYOR_CODE not in", values, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeBetween(String value1, String value2) {
            addCriterion("PAYOR_CODE between", value1, value2, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotBetween(String value1, String value2) {
            addCriterion("PAYOR_CODE not between", value1, value2, "payorCode");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusIsNull() {
            addCriterion("NEW_CLAIMS_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusIsNotNull() {
            addCriterion("NEW_CLAIMS_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusEqualTo(String value) {
            addCriterion("NEW_CLAIMS_STATUS =", value, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusNotEqualTo(String value) {
            addCriterion("NEW_CLAIMS_STATUS <>", value, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusGreaterThan(String value) {
            addCriterion("NEW_CLAIMS_STATUS >", value, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusGreaterThanOrEqualTo(String value) {
            addCriterion("NEW_CLAIMS_STATUS >=", value, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusLessThan(String value) {
            addCriterion("NEW_CLAIMS_STATUS <", value, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusLessThanOrEqualTo(String value) {
            addCriterion("NEW_CLAIMS_STATUS <=", value, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusLike(String value) {
            addCriterion("NEW_CLAIMS_STATUS like", value, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusNotLike(String value) {
            addCriterion("NEW_CLAIMS_STATUS not like", value, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusIn(List<String> values) {
            addCriterion("NEW_CLAIMS_STATUS in", values, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusNotIn(List<String> values) {
            addCriterion("NEW_CLAIMS_STATUS not in", values, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusBetween(String value1, String value2) {
            addCriterion("NEW_CLAIMS_STATUS between", value1, value2, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andNewClaimsStatusNotBetween(String value1, String value2) {
            addCriterion("NEW_CLAIMS_STATUS not between", value1, value2, "newClaimsStatus");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoIsNull() {
            addCriterion("ACTION_SEQNO is null");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoIsNotNull() {
            addCriterion("ACTION_SEQNO is not null");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoEqualTo(Integer value) {
            addCriterion("ACTION_SEQNO =", value, "actionSeqno");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoNotEqualTo(Integer value) {
            addCriterion("ACTION_SEQNO <>", value, "actionSeqno");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoGreaterThan(Integer value) {
            addCriterion("ACTION_SEQNO >", value, "actionSeqno");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoGreaterThanOrEqualTo(Integer value) {
            addCriterion("ACTION_SEQNO >=", value, "actionSeqno");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoLessThan(Integer value) {
            addCriterion("ACTION_SEQNO <", value, "actionSeqno");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoLessThanOrEqualTo(Integer value) {
            addCriterion("ACTION_SEQNO <=", value, "actionSeqno");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoIn(List<Integer> values) {
            addCriterion("ACTION_SEQNO in", values, "actionSeqno");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoNotIn(List<Integer> values) {
            addCriterion("ACTION_SEQNO not in", values, "actionSeqno");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoBetween(Integer value1, Integer value2) {
            addCriterion("ACTION_SEQNO between", value1, value2, "actionSeqno");
            return (Criteria) this;
        }

        public Criteria andActionSeqnoNotBetween(Integer value1, Integer value2) {
            addCriterion("ACTION_SEQNO not between", value1, value2, "actionSeqno");
            return (Criteria) this;
        }

        public Criteria andActionByIsNull() {
            addCriterion("ACTION_BY is null");
            return (Criteria) this;
        }

        public Criteria andActionByIsNotNull() {
            addCriterion("ACTION_BY is not null");
            return (Criteria) this;
        }

        public Criteria andActionByEqualTo(String value) {
            addCriterion("ACTION_BY =", value, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionByNotEqualTo(String value) {
            addCriterion("ACTION_BY <>", value, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionByGreaterThan(String value) {
            addCriterion("ACTION_BY >", value, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionByGreaterThanOrEqualTo(String value) {
            addCriterion("ACTION_BY >=", value, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionByLessThan(String value) {
            addCriterion("ACTION_BY <", value, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionByLessThanOrEqualTo(String value) {
            addCriterion("ACTION_BY <=", value, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionByLike(String value) {
            addCriterion("ACTION_BY like", value, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionByNotLike(String value) {
            addCriterion("ACTION_BY not like", value, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionByIn(List<String> values) {
            addCriterion("ACTION_BY in", values, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionByNotIn(List<String> values) {
            addCriterion("ACTION_BY not in", values, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionByBetween(String value1, String value2) {
            addCriterion("ACTION_BY between", value1, value2, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionByNotBetween(String value1, String value2) {
            addCriterion("ACTION_BY not between", value1, value2, "actionBy");
            return (Criteria) this;
        }

        public Criteria andActionDateIsNull() {
            addCriterion("ACTION_DATE is null");
            return (Criteria) this;
        }

        public Criteria andActionDateIsNotNull() {
            addCriterion("ACTION_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andActionDateEqualTo(Date value) {
            addCriterion("ACTION_DATE =", value, "actionDate");
            return (Criteria) this;
        }

        public Criteria andActionDateNotEqualTo(Date value) {
            addCriterion("ACTION_DATE <>", value, "actionDate");
            return (Criteria) this;
        }

        public Criteria andActionDateGreaterThan(Date value) {
            addCriterion("ACTION_DATE >", value, "actionDate");
            return (Criteria) this;
        }

        public Criteria andActionDateGreaterThanOrEqualTo(Date value) {
            addCriterion("ACTION_DATE >=", value, "actionDate");
            return (Criteria) this;
        }

        public Criteria andActionDateLessThan(Date value) {
            addCriterion("ACTION_DATE <", value, "actionDate");
            return (Criteria) this;
        }

        public Criteria andActionDateLessThanOrEqualTo(Date value) {
            addCriterion("ACTION_DATE <=", value, "actionDate");
            return (Criteria) this;
        }

        public Criteria andActionDateIn(List<Date> values) {
            addCriterion("ACTION_DATE in", values, "actionDate");
            return (Criteria) this;
        }

        public Criteria andActionDateNotIn(List<Date> values) {
            addCriterion("ACTION_DATE not in", values, "actionDate");
            return (Criteria) this;
        }

        public Criteria andActionDateBetween(Date value1, Date value2) {
            addCriterion("ACTION_DATE between", value1, value2, "actionDate");
            return (Criteria) this;
        }

        public Criteria andActionDateNotBetween(Date value1, Date value2) {
            addCriterion("ACTION_DATE not between", value1, value2, "actionDate");
            return (Criteria) this;
        }

        public Criteria andActionRemIsNull() {
            addCriterion("ACTION_REM is null");
            return (Criteria) this;
        }

        public Criteria andActionRemIsNotNull() {
            addCriterion("ACTION_REM is not null");
            return (Criteria) this;
        }

        public Criteria andActionRemEqualTo(String value) {
            addCriterion("ACTION_REM =", value, "actionRem");
            return (Criteria) this;
        }

        public Criteria andActionRemNotEqualTo(String value) {
            addCriterion("ACTION_REM <>", value, "actionRem");
            return (Criteria) this;
        }

        public Criteria andActionRemGreaterThan(String value) {
            addCriterion("ACTION_REM >", value, "actionRem");
            return (Criteria) this;
        }

        public Criteria andActionRemGreaterThanOrEqualTo(String value) {
            addCriterion("ACTION_REM >=", value, "actionRem");
            return (Criteria) this;
        }

        public Criteria andActionRemLessThan(String value) {
            addCriterion("ACTION_REM <", value, "actionRem");
            return (Criteria) this;
        }

        public Criteria andActionRemLessThanOrEqualTo(String value) {
            addCriterion("ACTION_REM <=", value, "actionRem");
            return (Criteria) this;
        }

        public Criteria andActionRemLike(String value) {
            addCriterion("ACTION_REM like", value, "actionRem");
            return (Criteria) this;
        }

        public Criteria andActionRemNotLike(String value) {
            addCriterion("ACTION_REM not like", value, "actionRem");
            return (Criteria) this;
        }

        public Criteria andActionRemIn(List<String> values) {
            addCriterion("ACTION_REM in", values, "actionRem");
            return (Criteria) this;
        }

        public Criteria andActionRemNotIn(List<String> values) {
            addCriterion("ACTION_REM not in", values, "actionRem");
            return (Criteria) this;
        }

        public Criteria andActionRemBetween(String value1, String value2) {
            addCriterion("ACTION_REM between", value1, value2, "actionRem");
            return (Criteria) this;
        }

        public Criteria andActionRemNotBetween(String value1, String value2) {
            addCriterion("ACTION_REM not between", value1, value2, "actionRem");
            return (Criteria) this;
        }

        public Criteria andUploadDateIsNull() {
            addCriterion("UPLOAD_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUploadDateIsNotNull() {
            addCriterion("UPLOAD_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUploadDateEqualTo(Date value) {
            addCriterion("UPLOAD_DATE =", value, "uploadDate");
            return (Criteria) this;
        }

        public Criteria andUploadDateNotEqualTo(Date value) {
            addCriterion("UPLOAD_DATE <>", value, "uploadDate");
            return (Criteria) this;
        }

        public Criteria andUploadDateGreaterThan(Date value) {
            addCriterion("UPLOAD_DATE >", value, "uploadDate");
            return (Criteria) this;
        }

        public Criteria andUploadDateGreaterThanOrEqualTo(Date value) {
            addCriterion("UPLOAD_DATE >=", value, "uploadDate");
            return (Criteria) this;
        }

        public Criteria andUploadDateLessThan(Date value) {
            addCriterion("UPLOAD_DATE <", value, "uploadDate");
            return (Criteria) this;
        }

        public Criteria andUploadDateLessThanOrEqualTo(Date value) {
            addCriterion("UPLOAD_DATE <=", value, "uploadDate");
            return (Criteria) this;
        }

        public Criteria andUploadDateIn(List<Date> values) {
            addCriterion("UPLOAD_DATE in", values, "uploadDate");
            return (Criteria) this;
        }

        public Criteria andUploadDateNotIn(List<Date> values) {
            addCriterion("UPLOAD_DATE not in", values, "uploadDate");
            return (Criteria) this;
        }

        public Criteria andUploadDateBetween(Date value1, Date value2) {
            addCriterion("UPLOAD_DATE between", value1, value2, "uploadDate");
            return (Criteria) this;
        }

        public Criteria andUploadDateNotBetween(Date value1, Date value2) {
            addCriterion("UPLOAD_DATE not between", value1, value2, "uploadDate");
            return (Criteria) this;
        }

        public Criteria andFaxLogIsNull() {
            addCriterion("FAX_LOG is null");
            return (Criteria) this;
        }

        public Criteria andFaxLogIsNotNull() {
            addCriterion("FAX_LOG is not null");
            return (Criteria) this;
        }

        public Criteria andFaxLogEqualTo(String value) {
            addCriterion("FAX_LOG =", value, "faxLog");
            return (Criteria) this;
        }

        public Criteria andFaxLogNotEqualTo(String value) {
            addCriterion("FAX_LOG <>", value, "faxLog");
            return (Criteria) this;
        }

        public Criteria andFaxLogGreaterThan(String value) {
            addCriterion("FAX_LOG >", value, "faxLog");
            return (Criteria) this;
        }

        public Criteria andFaxLogGreaterThanOrEqualTo(String value) {
            addCriterion("FAX_LOG >=", value, "faxLog");
            return (Criteria) this;
        }

        public Criteria andFaxLogLessThan(String value) {
            addCriterion("FAX_LOG <", value, "faxLog");
            return (Criteria) this;
        }

        public Criteria andFaxLogLessThanOrEqualTo(String value) {
            addCriterion("FAX_LOG <=", value, "faxLog");
            return (Criteria) this;
        }

        public Criteria andFaxLogLike(String value) {
            addCriterion("FAX_LOG like", value, "faxLog");
            return (Criteria) this;
        }

        public Criteria andFaxLogNotLike(String value) {
            addCriterion("FAX_LOG not like", value, "faxLog");
            return (Criteria) this;
        }

        public Criteria andFaxLogIn(List<String> values) {
            addCriterion("FAX_LOG in", values, "faxLog");
            return (Criteria) this;
        }

        public Criteria andFaxLogNotIn(List<String> values) {
            addCriterion("FAX_LOG not in", values, "faxLog");
            return (Criteria) this;
        }

        public Criteria andFaxLogBetween(String value1, String value2) {
            addCriterion("FAX_LOG between", value1, value2, "faxLog");
            return (Criteria) this;
        }

        public Criteria andFaxLogNotBetween(String value1, String value2) {
            addCriterion("FAX_LOG not between", value1, value2, "faxLog");
            return (Criteria) this;
        }

        public Criteria andReservedDayIsNull() {
            addCriterion("RESERVED_DAY is null");
            return (Criteria) this;
        }

        public Criteria andReservedDayIsNotNull() {
            addCriterion("RESERVED_DAY is not null");
            return (Criteria) this;
        }

        public Criteria andReservedDayEqualTo(BigDecimal value) {
            addCriterion("RESERVED_DAY =", value, "reservedDay");
            return (Criteria) this;
        }

        public Criteria andReservedDayNotEqualTo(BigDecimal value) {
            addCriterion("RESERVED_DAY <>", value, "reservedDay");
            return (Criteria) this;
        }

        public Criteria andReservedDayGreaterThan(BigDecimal value) {
            addCriterion("RESERVED_DAY >", value, "reservedDay");
            return (Criteria) this;
        }

        public Criteria andReservedDayGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RESERVED_DAY >=", value, "reservedDay");
            return (Criteria) this;
        }

        public Criteria andReservedDayLessThan(BigDecimal value) {
            addCriterion("RESERVED_DAY <", value, "reservedDay");
            return (Criteria) this;
        }

        public Criteria andReservedDayLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RESERVED_DAY <=", value, "reservedDay");
            return (Criteria) this;
        }

        public Criteria andReservedDayIn(List<BigDecimal> values) {
            addCriterion("RESERVED_DAY in", values, "reservedDay");
            return (Criteria) this;
        }

        public Criteria andReservedDayNotIn(List<BigDecimal> values) {
            addCriterion("RESERVED_DAY not in", values, "reservedDay");
            return (Criteria) this;
        }

        public Criteria andReservedDayBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RESERVED_DAY between", value1, value2, "reservedDay");
            return (Criteria) this;
        }

        public Criteria andReservedDayNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RESERVED_DAY not between", value1, value2, "reservedDay");
            return (Criteria) this;
        }

        public Criteria andJournalNoIsNull() {
            addCriterion("JOURNAL_NO is null");
            return (Criteria) this;
        }

        public Criteria andJournalNoIsNotNull() {
            addCriterion("JOURNAL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andJournalNoEqualTo(Long value) {
            addCriterion("JOURNAL_NO =", value, "journalNo");
            return (Criteria) this;
        }

        public Criteria andJournalNoNotEqualTo(Long value) {
            addCriterion("JOURNAL_NO <>", value, "journalNo");
            return (Criteria) this;
        }

        public Criteria andJournalNoGreaterThan(Long value) {
            addCriterion("JOURNAL_NO >", value, "journalNo");
            return (Criteria) this;
        }

        public Criteria andJournalNoGreaterThanOrEqualTo(Long value) {
            addCriterion("JOURNAL_NO >=", value, "journalNo");
            return (Criteria) this;
        }

        public Criteria andJournalNoLessThan(Long value) {
            addCriterion("JOURNAL_NO <", value, "journalNo");
            return (Criteria) this;
        }

        public Criteria andJournalNoLessThanOrEqualTo(Long value) {
            addCriterion("JOURNAL_NO <=", value, "journalNo");
            return (Criteria) this;
        }

        public Criteria andJournalNoIn(List<Long> values) {
            addCriterion("JOURNAL_NO in", values, "journalNo");
            return (Criteria) this;
        }

        public Criteria andJournalNoNotIn(List<Long> values) {
            addCriterion("JOURNAL_NO not in", values, "journalNo");
            return (Criteria) this;
        }

        public Criteria andJournalNoBetween(Long value1, Long value2) {
            addCriterion("JOURNAL_NO between", value1, value2, "journalNo");
            return (Criteria) this;
        }

        public Criteria andJournalNoNotBetween(Long value1, Long value2) {
            addCriterion("JOURNAL_NO not between", value1, value2, "journalNo");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateIsNull() {
            addCriterion("DOCRCV_DATE is null");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateIsNotNull() {
            addCriterion("DOCRCV_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateEqualTo(Date value) {
            addCriterion("DOCRCV_DATE =", value, "docrcvDate");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateNotEqualTo(Date value) {
            addCriterion("DOCRCV_DATE <>", value, "docrcvDate");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateGreaterThan(Date value) {
            addCriterion("DOCRCV_DATE >", value, "docrcvDate");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateGreaterThanOrEqualTo(Date value) {
            addCriterion("DOCRCV_DATE >=", value, "docrcvDate");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateLessThan(Date value) {
            addCriterion("DOCRCV_DATE <", value, "docrcvDate");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateLessThanOrEqualTo(Date value) {
            addCriterion("DOCRCV_DATE <=", value, "docrcvDate");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateIn(List<Date> values) {
            addCriterion("DOCRCV_DATE in", values, "docrcvDate");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateNotIn(List<Date> values) {
            addCriterion("DOCRCV_DATE not in", values, "docrcvDate");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateBetween(Date value1, Date value2) {
            addCriterion("DOCRCV_DATE between", value1, value2, "docrcvDate");
            return (Criteria) this;
        }

        public Criteria andDocrcvDateNotBetween(Date value1, Date value2) {
            addCriterion("DOCRCV_DATE not between", value1, value2, "docrcvDate");
            return (Criteria) this;
        }

        public Criteria andNotifyDateIsNull() {
            addCriterion("NOTIFY_DATE is null");
            return (Criteria) this;
        }

        public Criteria andNotifyDateIsNotNull() {
            addCriterion("NOTIFY_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andNotifyDateEqualTo(Date value) {
            addCriterion("NOTIFY_DATE =", value, "notifyDate");
            return (Criteria) this;
        }

        public Criteria andNotifyDateNotEqualTo(Date value) {
            addCriterion("NOTIFY_DATE <>", value, "notifyDate");
            return (Criteria) this;
        }

        public Criteria andNotifyDateGreaterThan(Date value) {
            addCriterion("NOTIFY_DATE >", value, "notifyDate");
            return (Criteria) this;
        }

        public Criteria andNotifyDateGreaterThanOrEqualTo(Date value) {
            addCriterion("NOTIFY_DATE >=", value, "notifyDate");
            return (Criteria) this;
        }

        public Criteria andNotifyDateLessThan(Date value) {
            addCriterion("NOTIFY_DATE <", value, "notifyDate");
            return (Criteria) this;
        }

        public Criteria andNotifyDateLessThanOrEqualTo(Date value) {
            addCriterion("NOTIFY_DATE <=", value, "notifyDate");
            return (Criteria) this;
        }

        public Criteria andNotifyDateIn(List<Date> values) {
            addCriterion("NOTIFY_DATE in", values, "notifyDate");
            return (Criteria) this;
        }

        public Criteria andNotifyDateNotIn(List<Date> values) {
            addCriterion("NOTIFY_DATE not in", values, "notifyDate");
            return (Criteria) this;
        }

        public Criteria andNotifyDateBetween(Date value1, Date value2) {
            addCriterion("NOTIFY_DATE between", value1, value2, "notifyDate");
            return (Criteria) this;
        }

        public Criteria andNotifyDateNotBetween(Date value1, Date value2) {
            addCriterion("NOTIFY_DATE not between", value1, value2, "notifyDate");
            return (Criteria) this;
        }

        public Criteria andDefercdIsNull() {
            addCriterion("DEFERCD is null");
            return (Criteria) this;
        }

        public Criteria andDefercdIsNotNull() {
            addCriterion("DEFERCD is not null");
            return (Criteria) this;
        }

        public Criteria andDefercdEqualTo(String value) {
            addCriterion("DEFERCD =", value, "defercd");
            return (Criteria) this;
        }

        public Criteria andDefercdNotEqualTo(String value) {
            addCriterion("DEFERCD <>", value, "defercd");
            return (Criteria) this;
        }

        public Criteria andDefercdGreaterThan(String value) {
            addCriterion("DEFERCD >", value, "defercd");
            return (Criteria) this;
        }

        public Criteria andDefercdGreaterThanOrEqualTo(String value) {
            addCriterion("DEFERCD >=", value, "defercd");
            return (Criteria) this;
        }

        public Criteria andDefercdLessThan(String value) {
            addCriterion("DEFERCD <", value, "defercd");
            return (Criteria) this;
        }

        public Criteria andDefercdLessThanOrEqualTo(String value) {
            addCriterion("DEFERCD <=", value, "defercd");
            return (Criteria) this;
        }

        public Criteria andDefercdLike(String value) {
            addCriterion("DEFERCD like", value, "defercd");
            return (Criteria) this;
        }

        public Criteria andDefercdNotLike(String value) {
            addCriterion("DEFERCD not like", value, "defercd");
            return (Criteria) this;
        }

        public Criteria andDefercdIn(List<String> values) {
            addCriterion("DEFERCD in", values, "defercd");
            return (Criteria) this;
        }

        public Criteria andDefercdNotIn(List<String> values) {
            addCriterion("DEFERCD not in", values, "defercd");
            return (Criteria) this;
        }

        public Criteria andDefercdBetween(String value1, String value2) {
            addCriterion("DEFERCD between", value1, value2, "defercd");
            return (Criteria) this;
        }

        public Criteria andDefercdNotBetween(String value1, String value2) {
            addCriterion("DEFERCD not between", value1, value2, "defercd");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateIsNull() {
            addCriterion("VERIFIED_DATE is null");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateIsNotNull() {
            addCriterion("VERIFIED_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateEqualTo(Date value) {
            addCriterion("VERIFIED_DATE =", value, "verifiedDate");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateNotEqualTo(Date value) {
            addCriterion("VERIFIED_DATE <>", value, "verifiedDate");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateGreaterThan(Date value) {
            addCriterion("VERIFIED_DATE >", value, "verifiedDate");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateGreaterThanOrEqualTo(Date value) {
            addCriterion("VERIFIED_DATE >=", value, "verifiedDate");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateLessThan(Date value) {
            addCriterion("VERIFIED_DATE <", value, "verifiedDate");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateLessThanOrEqualTo(Date value) {
            addCriterion("VERIFIED_DATE <=", value, "verifiedDate");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateIn(List<Date> values) {
            addCriterion("VERIFIED_DATE in", values, "verifiedDate");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateNotIn(List<Date> values) {
            addCriterion("VERIFIED_DATE not in", values, "verifiedDate");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateBetween(Date value1, Date value2) {
            addCriterion("VERIFIED_DATE between", value1, value2, "verifiedDate");
            return (Criteria) this;
        }

        public Criteria andVerifiedDateNotBetween(Date value1, Date value2) {
            addCriterion("VERIFIED_DATE not between", value1, value2, "verifiedDate");
            return (Criteria) this;
        }

        public Criteria andVerifiedByIsNull() {
            addCriterion("VERIFIED_BY is null");
            return (Criteria) this;
        }

        public Criteria andVerifiedByIsNotNull() {
            addCriterion("VERIFIED_BY is not null");
            return (Criteria) this;
        }

        public Criteria andVerifiedByEqualTo(String value) {
            addCriterion("VERIFIED_BY =", value, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedByNotEqualTo(String value) {
            addCriterion("VERIFIED_BY <>", value, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedByGreaterThan(String value) {
            addCriterion("VERIFIED_BY >", value, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedByGreaterThanOrEqualTo(String value) {
            addCriterion("VERIFIED_BY >=", value, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedByLessThan(String value) {
            addCriterion("VERIFIED_BY <", value, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedByLessThanOrEqualTo(String value) {
            addCriterion("VERIFIED_BY <=", value, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedByLike(String value) {
            addCriterion("VERIFIED_BY like", value, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedByNotLike(String value) {
            addCriterion("VERIFIED_BY not like", value, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedByIn(List<String> values) {
            addCriterion("VERIFIED_BY in", values, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedByNotIn(List<String> values) {
            addCriterion("VERIFIED_BY not in", values, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedByBetween(String value1, String value2) {
            addCriterion("VERIFIED_BY between", value1, value2, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedByNotBetween(String value1, String value2) {
            addCriterion("VERIFIED_BY not between", value1, value2, "verifiedBy");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeIsNull() {
            addCriterion("VERIFIED_CODE is null");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeIsNotNull() {
            addCriterion("VERIFIED_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeEqualTo(String value) {
            addCriterion("VERIFIED_CODE =", value, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeNotEqualTo(String value) {
            addCriterion("VERIFIED_CODE <>", value, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeGreaterThan(String value) {
            addCriterion("VERIFIED_CODE >", value, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeGreaterThanOrEqualTo(String value) {
            addCriterion("VERIFIED_CODE >=", value, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeLessThan(String value) {
            addCriterion("VERIFIED_CODE <", value, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeLessThanOrEqualTo(String value) {
            addCriterion("VERIFIED_CODE <=", value, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeLike(String value) {
            addCriterion("VERIFIED_CODE like", value, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeNotLike(String value) {
            addCriterion("VERIFIED_CODE not like", value, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeIn(List<String> values) {
            addCriterion("VERIFIED_CODE in", values, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeNotIn(List<String> values) {
            addCriterion("VERIFIED_CODE not in", values, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeBetween(String value1, String value2) {
            addCriterion("VERIFIED_CODE between", value1, value2, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedCodeNotBetween(String value1, String value2) {
            addCriterion("VERIFIED_CODE not between", value1, value2, "verifiedCode");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemIsNull() {
            addCriterion("VERIFIED_REM is null");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemIsNotNull() {
            addCriterion("VERIFIED_REM is not null");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemEqualTo(String value) {
            addCriterion("VERIFIED_REM =", value, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemNotEqualTo(String value) {
            addCriterion("VERIFIED_REM <>", value, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemGreaterThan(String value) {
            addCriterion("VERIFIED_REM >", value, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemGreaterThanOrEqualTo(String value) {
            addCriterion("VERIFIED_REM >=", value, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemLessThan(String value) {
            addCriterion("VERIFIED_REM <", value, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemLessThanOrEqualTo(String value) {
            addCriterion("VERIFIED_REM <=", value, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemLike(String value) {
            addCriterion("VERIFIED_REM like", value, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemNotLike(String value) {
            addCriterion("VERIFIED_REM not like", value, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemIn(List<String> values) {
            addCriterion("VERIFIED_REM in", values, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemNotIn(List<String> values) {
            addCriterion("VERIFIED_REM not in", values, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemBetween(String value1, String value2) {
            addCriterion("VERIFIED_REM between", value1, value2, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedRemNotBetween(String value1, String value2) {
            addCriterion("VERIFIED_REM not between", value1, value2, "verifiedRem");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityIsNull() {
            addCriterion("VERIFIED_LIABILITY is null");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityIsNotNull() {
            addCriterion("VERIFIED_LIABILITY is not null");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityEqualTo(BigDecimal value) {
            addCriterion("VERIFIED_LIABILITY =", value, "verifiedLiability");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityNotEqualTo(BigDecimal value) {
            addCriterion("VERIFIED_LIABILITY <>", value, "verifiedLiability");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityGreaterThan(BigDecimal value) {
            addCriterion("VERIFIED_LIABILITY >", value, "verifiedLiability");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("VERIFIED_LIABILITY >=", value, "verifiedLiability");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityLessThan(BigDecimal value) {
            addCriterion("VERIFIED_LIABILITY <", value, "verifiedLiability");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityLessThanOrEqualTo(BigDecimal value) {
            addCriterion("VERIFIED_LIABILITY <=", value, "verifiedLiability");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityIn(List<BigDecimal> values) {
            addCriterion("VERIFIED_LIABILITY in", values, "verifiedLiability");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityNotIn(List<BigDecimal> values) {
            addCriterion("VERIFIED_LIABILITY not in", values, "verifiedLiability");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VERIFIED_LIABILITY between", value1, value2, "verifiedLiability");
            return (Criteria) this;
        }

        public Criteria andVerifiedLiabilityNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VERIFIED_LIABILITY not between", value1, value2, "verifiedLiability");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksIsNull() {
            addCriterion("PRIVATE_REMARKS is null");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksIsNotNull() {
            addCriterion("PRIVATE_REMARKS is not null");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksEqualTo(String value) {
            addCriterion("PRIVATE_REMARKS =", value, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksNotEqualTo(String value) {
            addCriterion("PRIVATE_REMARKS <>", value, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksGreaterThan(String value) {
            addCriterion("PRIVATE_REMARKS >", value, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("PRIVATE_REMARKS >=", value, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksLessThan(String value) {
            addCriterion("PRIVATE_REMARKS <", value, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksLessThanOrEqualTo(String value) {
            addCriterion("PRIVATE_REMARKS <=", value, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksLike(String value) {
            addCriterion("PRIVATE_REMARKS like", value, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksNotLike(String value) {
            addCriterion("PRIVATE_REMARKS not like", value, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksIn(List<String> values) {
            addCriterion("PRIVATE_REMARKS in", values, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksNotIn(List<String> values) {
            addCriterion("PRIVATE_REMARKS not in", values, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksBetween(String value1, String value2) {
            addCriterion("PRIVATE_REMARKS between", value1, value2, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andPrivateRemarksNotBetween(String value1, String value2) {
            addCriterion("PRIVATE_REMARKS not between", value1, value2, "privateRemarks");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormIsNull() {
            addCriterion("INCOMPLETE_FORM is null");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormIsNotNull() {
            addCriterion("INCOMPLETE_FORM is not null");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormEqualTo(String value) {
            addCriterion("INCOMPLETE_FORM =", value, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormNotEqualTo(String value) {
            addCriterion("INCOMPLETE_FORM <>", value, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormGreaterThan(String value) {
            addCriterion("INCOMPLETE_FORM >", value, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormGreaterThanOrEqualTo(String value) {
            addCriterion("INCOMPLETE_FORM >=", value, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormLessThan(String value) {
            addCriterion("INCOMPLETE_FORM <", value, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormLessThanOrEqualTo(String value) {
            addCriterion("INCOMPLETE_FORM <=", value, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormLike(String value) {
            addCriterion("INCOMPLETE_FORM like", value, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormNotLike(String value) {
            addCriterion("INCOMPLETE_FORM not like", value, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormIn(List<String> values) {
            addCriterion("INCOMPLETE_FORM in", values, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormNotIn(List<String> values) {
            addCriterion("INCOMPLETE_FORM not in", values, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormBetween(String value1, String value2) {
            addCriterion("INCOMPLETE_FORM between", value1, value2, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteFormNotBetween(String value1, String value2) {
            addCriterion("INCOMPLETE_FORM not between", value1, value2, "incompleteForm");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportIsNull() {
            addCriterion("INCOMPLETE_REPORT is null");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportIsNotNull() {
            addCriterion("INCOMPLETE_REPORT is not null");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportEqualTo(String value) {
            addCriterion("INCOMPLETE_REPORT =", value, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportNotEqualTo(String value) {
            addCriterion("INCOMPLETE_REPORT <>", value, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportGreaterThan(String value) {
            addCriterion("INCOMPLETE_REPORT >", value, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportGreaterThanOrEqualTo(String value) {
            addCriterion("INCOMPLETE_REPORT >=", value, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportLessThan(String value) {
            addCriterion("INCOMPLETE_REPORT <", value, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportLessThanOrEqualTo(String value) {
            addCriterion("INCOMPLETE_REPORT <=", value, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportLike(String value) {
            addCriterion("INCOMPLETE_REPORT like", value, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportNotLike(String value) {
            addCriterion("INCOMPLETE_REPORT not like", value, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportIn(List<String> values) {
            addCriterion("INCOMPLETE_REPORT in", values, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportNotIn(List<String> values) {
            addCriterion("INCOMPLETE_REPORT not in", values, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportBetween(String value1, String value2) {
            addCriterion("INCOMPLETE_REPORT between", value1, value2, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andIncompleteReportNotBetween(String value1, String value2) {
            addCriterion("INCOMPLETE_REPORT not between", value1, value2, "incompleteReport");
            return (Criteria) this;
        }

        public Criteria andReminderIsNull() {
            addCriterion("REMINDER is null");
            return (Criteria) this;
        }

        public Criteria andReminderIsNotNull() {
            addCriterion("REMINDER is not null");
            return (Criteria) this;
        }

        public Criteria andReminderEqualTo(Short value) {
            addCriterion("REMINDER =", value, "reminder");
            return (Criteria) this;
        }

        public Criteria andReminderNotEqualTo(Short value) {
            addCriterion("REMINDER <>", value, "reminder");
            return (Criteria) this;
        }

        public Criteria andReminderGreaterThan(Short value) {
            addCriterion("REMINDER >", value, "reminder");
            return (Criteria) this;
        }

        public Criteria andReminderGreaterThanOrEqualTo(Short value) {
            addCriterion("REMINDER >=", value, "reminder");
            return (Criteria) this;
        }

        public Criteria andReminderLessThan(Short value) {
            addCriterion("REMINDER <", value, "reminder");
            return (Criteria) this;
        }

        public Criteria andReminderLessThanOrEqualTo(Short value) {
            addCriterion("REMINDER <=", value, "reminder");
            return (Criteria) this;
        }

        public Criteria andReminderIn(List<Short> values) {
            addCriterion("REMINDER in", values, "reminder");
            return (Criteria) this;
        }

        public Criteria andReminderNotIn(List<Short> values) {
            addCriterion("REMINDER not in", values, "reminder");
            return (Criteria) this;
        }

        public Criteria andReminderBetween(Short value1, Short value2) {
            addCriterion("REMINDER between", value1, value2, "reminder");
            return (Criteria) this;
        }

        public Criteria andReminderNotBetween(Short value1, Short value2) {
            addCriterion("REMINDER not between", value1, value2, "reminder");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportIsNull() {
            addCriterion("DOCRCV_REPORT is null");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportIsNotNull() {
            addCriterion("DOCRCV_REPORT is not null");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportEqualTo(String value) {
            addCriterion("DOCRCV_REPORT =", value, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportNotEqualTo(String value) {
            addCriterion("DOCRCV_REPORT <>", value, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportGreaterThan(String value) {
            addCriterion("DOCRCV_REPORT >", value, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportGreaterThanOrEqualTo(String value) {
            addCriterion("DOCRCV_REPORT >=", value, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportLessThan(String value) {
            addCriterion("DOCRCV_REPORT <", value, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportLessThanOrEqualTo(String value) {
            addCriterion("DOCRCV_REPORT <=", value, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportLike(String value) {
            addCriterion("DOCRCV_REPORT like", value, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportNotLike(String value) {
            addCriterion("DOCRCV_REPORT not like", value, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportIn(List<String> values) {
            addCriterion("DOCRCV_REPORT in", values, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportNotIn(List<String> values) {
            addCriterion("DOCRCV_REPORT not in", values, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportBetween(String value1, String value2) {
            addCriterion("DOCRCV_REPORT between", value1, value2, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andDocrcvReportNotBetween(String value1, String value2) {
            addCriterion("DOCRCV_REPORT not between", value1, value2, "docrcvReport");
            return (Criteria) this;
        }

        public Criteria andIcdCodeIsNull() {
            addCriterion("ICD_CODE is null");
            return (Criteria) this;
        }

        public Criteria andIcdCodeIsNotNull() {
            addCriterion("ICD_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andIcdCodeEqualTo(String value) {
            addCriterion("ICD_CODE =", value, "icdCode");
            return (Criteria) this;
        }

        public Criteria andIcdCodeNotEqualTo(String value) {
            addCriterion("ICD_CODE <>", value, "icdCode");
            return (Criteria) this;
        }

        public Criteria andIcdCodeGreaterThan(String value) {
            addCriterion("ICD_CODE >", value, "icdCode");
            return (Criteria) this;
        }

        public Criteria andIcdCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ICD_CODE >=", value, "icdCode");
            return (Criteria) this;
        }

        public Criteria andIcdCodeLessThan(String value) {
            addCriterion("ICD_CODE <", value, "icdCode");
            return (Criteria) this;
        }

        public Criteria andIcdCodeLessThanOrEqualTo(String value) {
            addCriterion("ICD_CODE <=", value, "icdCode");
            return (Criteria) this;
        }

        public Criteria andIcdCodeLike(String value) {
            addCriterion("ICD_CODE like", value, "icdCode");
            return (Criteria) this;
        }

        public Criteria andIcdCodeNotLike(String value) {
            addCriterion("ICD_CODE not like", value, "icdCode");
            return (Criteria) this;
        }

        public Criteria andIcdCodeIn(List<String> values) {
            addCriterion("ICD_CODE in", values, "icdCode");
            return (Criteria) this;
        }

        public Criteria andIcdCodeNotIn(List<String> values) {
            addCriterion("ICD_CODE not in", values, "icdCode");
            return (Criteria) this;
        }

        public Criteria andIcdCodeBetween(String value1, String value2) {
            addCriterion("ICD_CODE between", value1, value2, "icdCode");
            return (Criteria) this;
        }

        public Criteria andIcdCodeNotBetween(String value1, String value2) {
            addCriterion("ICD_CODE not between", value1, value2, "icdCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeIsNull() {
            addCriterion("CPT_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCptCodeIsNotNull() {
            addCriterion("CPT_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCptCodeEqualTo(String value) {
            addCriterion("CPT_CODE =", value, "cptCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeNotEqualTo(String value) {
            addCriterion("CPT_CODE <>", value, "cptCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeGreaterThan(String value) {
            addCriterion("CPT_CODE >", value, "cptCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CPT_CODE >=", value, "cptCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeLessThan(String value) {
            addCriterion("CPT_CODE <", value, "cptCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeLessThanOrEqualTo(String value) {
            addCriterion("CPT_CODE <=", value, "cptCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeLike(String value) {
            addCriterion("CPT_CODE like", value, "cptCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeNotLike(String value) {
            addCriterion("CPT_CODE not like", value, "cptCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeIn(List<String> values) {
            addCriterion("CPT_CODE in", values, "cptCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeNotIn(List<String> values) {
            addCriterion("CPT_CODE not in", values, "cptCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeBetween(String value1, String value2) {
            addCriterion("CPT_CODE between", value1, value2, "cptCode");
            return (Criteria) this;
        }

        public Criteria andCptCodeNotBetween(String value1, String value2) {
            addCriterion("CPT_CODE not between", value1, value2, "cptCode");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateIsNull() {
            addCriterion("DOCFAX_DATE is null");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateIsNotNull() {
            addCriterion("DOCFAX_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateEqualTo(Date value) {
            addCriterion("DOCFAX_DATE =", value, "docfaxDate");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateNotEqualTo(Date value) {
            addCriterion("DOCFAX_DATE <>", value, "docfaxDate");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateGreaterThan(Date value) {
            addCriterion("DOCFAX_DATE >", value, "docfaxDate");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateGreaterThanOrEqualTo(Date value) {
            addCriterion("DOCFAX_DATE >=", value, "docfaxDate");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateLessThan(Date value) {
            addCriterion("DOCFAX_DATE <", value, "docfaxDate");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateLessThanOrEqualTo(Date value) {
            addCriterion("DOCFAX_DATE <=", value, "docfaxDate");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateIn(List<Date> values) {
            addCriterion("DOCFAX_DATE in", values, "docfaxDate");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateNotIn(List<Date> values) {
            addCriterion("DOCFAX_DATE not in", values, "docfaxDate");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateBetween(Date value1, Date value2) {
            addCriterion("DOCFAX_DATE between", value1, value2, "docfaxDate");
            return (Criteria) this;
        }

        public Criteria andDocfaxDateNotBetween(Date value1, Date value2) {
            addCriterion("DOCFAX_DATE not between", value1, value2, "docfaxDate");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateIsNull() {
            addCriterion("LAST_DOCRCV_DATE is null");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateIsNotNull() {
            addCriterion("LAST_DOCRCV_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateEqualTo(Date value) {
            addCriterion("LAST_DOCRCV_DATE =", value, "lastDocrcvDate");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateNotEqualTo(Date value) {
            addCriterion("LAST_DOCRCV_DATE <>", value, "lastDocrcvDate");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateGreaterThan(Date value) {
            addCriterion("LAST_DOCRCV_DATE >", value, "lastDocrcvDate");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateGreaterThanOrEqualTo(Date value) {
            addCriterion("LAST_DOCRCV_DATE >=", value, "lastDocrcvDate");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateLessThan(Date value) {
            addCriterion("LAST_DOCRCV_DATE <", value, "lastDocrcvDate");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateLessThanOrEqualTo(Date value) {
            addCriterion("LAST_DOCRCV_DATE <=", value, "lastDocrcvDate");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateIn(List<Date> values) {
            addCriterion("LAST_DOCRCV_DATE in", values, "lastDocrcvDate");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateNotIn(List<Date> values) {
            addCriterion("LAST_DOCRCV_DATE not in", values, "lastDocrcvDate");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateBetween(Date value1, Date value2) {
            addCriterion("LAST_DOCRCV_DATE between", value1, value2, "lastDocrcvDate");
            return (Criteria) this;
        }

        public Criteria andLastDocrcvDateNotBetween(Date value1, Date value2) {
            addCriterion("LAST_DOCRCV_DATE not between", value1, value2, "lastDocrcvDate");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateIsNull() {
            addCriterion("LAST_DOCFAX_DATE is null");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateIsNotNull() {
            addCriterion("LAST_DOCFAX_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateEqualTo(Date value) {
            addCriterion("LAST_DOCFAX_DATE =", value, "lastDocfaxDate");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateNotEqualTo(Date value) {
            addCriterion("LAST_DOCFAX_DATE <>", value, "lastDocfaxDate");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateGreaterThan(Date value) {
            addCriterion("LAST_DOCFAX_DATE >", value, "lastDocfaxDate");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateGreaterThanOrEqualTo(Date value) {
            addCriterion("LAST_DOCFAX_DATE >=", value, "lastDocfaxDate");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateLessThan(Date value) {
            addCriterion("LAST_DOCFAX_DATE <", value, "lastDocfaxDate");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateLessThanOrEqualTo(Date value) {
            addCriterion("LAST_DOCFAX_DATE <=", value, "lastDocfaxDate");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateIn(List<Date> values) {
            addCriterion("LAST_DOCFAX_DATE in", values, "lastDocfaxDate");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateNotIn(List<Date> values) {
            addCriterion("LAST_DOCFAX_DATE not in", values, "lastDocfaxDate");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateBetween(Date value1, Date value2) {
            addCriterion("LAST_DOCFAX_DATE between", value1, value2, "lastDocfaxDate");
            return (Criteria) this;
        }

        public Criteria andLastDocfaxDateNotBetween(Date value1, Date value2) {
            addCriterion("LAST_DOCFAX_DATE not between", value1, value2, "lastDocfaxDate");
            return (Criteria) this;
        }

        public Criteria andCancelledDateIsNull() {
            addCriterion("CANCELLED_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCancelledDateIsNotNull() {
            addCriterion("CANCELLED_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCancelledDateEqualTo(Date value) {
            addCriterion("CANCELLED_DATE =", value, "cancelledDate");
            return (Criteria) this;
        }

        public Criteria andCancelledDateNotEqualTo(Date value) {
            addCriterion("CANCELLED_DATE <>", value, "cancelledDate");
            return (Criteria) this;
        }

        public Criteria andCancelledDateGreaterThan(Date value) {
            addCriterion("CANCELLED_DATE >", value, "cancelledDate");
            return (Criteria) this;
        }

        public Criteria andCancelledDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CANCELLED_DATE >=", value, "cancelledDate");
            return (Criteria) this;
        }

        public Criteria andCancelledDateLessThan(Date value) {
            addCriterion("CANCELLED_DATE <", value, "cancelledDate");
            return (Criteria) this;
        }

        public Criteria andCancelledDateLessThanOrEqualTo(Date value) {
            addCriterion("CANCELLED_DATE <=", value, "cancelledDate");
            return (Criteria) this;
        }

        public Criteria andCancelledDateIn(List<Date> values) {
            addCriterion("CANCELLED_DATE in", values, "cancelledDate");
            return (Criteria) this;
        }

        public Criteria andCancelledDateNotIn(List<Date> values) {
            addCriterion("CANCELLED_DATE not in", values, "cancelledDate");
            return (Criteria) this;
        }

        public Criteria andCancelledDateBetween(Date value1, Date value2) {
            addCriterion("CANCELLED_DATE between", value1, value2, "cancelledDate");
            return (Criteria) this;
        }

        public Criteria andCancelledDateNotBetween(Date value1, Date value2) {
            addCriterion("CANCELLED_DATE not between", value1, value2, "cancelledDate");
            return (Criteria) this;
        }

        public Criteria andCancelledByIsNull() {
            addCriterion("CANCELLED_BY is null");
            return (Criteria) this;
        }

        public Criteria andCancelledByIsNotNull() {
            addCriterion("CANCELLED_BY is not null");
            return (Criteria) this;
        }

        public Criteria andCancelledByEqualTo(String value) {
            addCriterion("CANCELLED_BY =", value, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andCancelledByNotEqualTo(String value) {
            addCriterion("CANCELLED_BY <>", value, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andCancelledByGreaterThan(String value) {
            addCriterion("CANCELLED_BY >", value, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andCancelledByGreaterThanOrEqualTo(String value) {
            addCriterion("CANCELLED_BY >=", value, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andCancelledByLessThan(String value) {
            addCriterion("CANCELLED_BY <", value, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andCancelledByLessThanOrEqualTo(String value) {
            addCriterion("CANCELLED_BY <=", value, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andCancelledByLike(String value) {
            addCriterion("CANCELLED_BY like", value, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andCancelledByNotLike(String value) {
            addCriterion("CANCELLED_BY not like", value, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andCancelledByIn(List<String> values) {
            addCriterion("CANCELLED_BY in", values, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andCancelledByNotIn(List<String> values) {
            addCriterion("CANCELLED_BY not in", values, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andCancelledByBetween(String value1, String value2) {
            addCriterion("CANCELLED_BY between", value1, value2, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andCancelledByNotBetween(String value1, String value2) {
            addCriterion("CANCELLED_BY not between", value1, value2, "cancelledBy");
            return (Criteria) this;
        }

        public Criteria andProviderNameIsNull() {
            addCriterion("PROVIDER_NAME is null");
            return (Criteria) this;
        }

        public Criteria andProviderNameIsNotNull() {
            addCriterion("PROVIDER_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andProviderNameEqualTo(String value) {
            addCriterion("PROVIDER_NAME =", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameNotEqualTo(String value) {
            addCriterion("PROVIDER_NAME <>", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameGreaterThan(String value) {
            addCriterion("PROVIDER_NAME >", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_NAME >=", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameLessThan(String value) {
            addCriterion("PROVIDER_NAME <", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_NAME <=", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameLike(String value) {
            addCriterion("PROVIDER_NAME like", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameNotLike(String value) {
            addCriterion("PROVIDER_NAME not like", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameIn(List<String> values) {
            addCriterion("PROVIDER_NAME in", values, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameNotIn(List<String> values) {
            addCriterion("PROVIDER_NAME not in", values, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameBetween(String value1, String value2) {
            addCriterion("PROVIDER_NAME between", value1, value2, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_NAME not between", value1, value2, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderAddressIsNull() {
            addCriterion("PROVIDER_ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andProviderAddressIsNotNull() {
            addCriterion("PROVIDER_ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andProviderAddressEqualTo(String value) {
            addCriterion("PROVIDER_ADDRESS =", value, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andProviderAddressNotEqualTo(String value) {
            addCriterion("PROVIDER_ADDRESS <>", value, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andProviderAddressGreaterThan(String value) {
            addCriterion("PROVIDER_ADDRESS >", value, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andProviderAddressGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_ADDRESS >=", value, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andProviderAddressLessThan(String value) {
            addCriterion("PROVIDER_ADDRESS <", value, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andProviderAddressLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_ADDRESS <=", value, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andProviderAddressLike(String value) {
            addCriterion("PROVIDER_ADDRESS like", value, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andProviderAddressNotLike(String value) {
            addCriterion("PROVIDER_ADDRESS not like", value, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andProviderAddressIn(List<String> values) {
            addCriterion("PROVIDER_ADDRESS in", values, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andProviderAddressNotIn(List<String> values) {
            addCriterion("PROVIDER_ADDRESS not in", values, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andProviderAddressBetween(String value1, String value2) {
            addCriterion("PROVIDER_ADDRESS between", value1, value2, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andProviderAddressNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_ADDRESS not between", value1, value2, "providerAddress");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksIsNull() {
            addCriterion("PAYMENT_REMARKS is null");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksIsNotNull() {
            addCriterion("PAYMENT_REMARKS is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksEqualTo(String value) {
            addCriterion("PAYMENT_REMARKS =", value, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksNotEqualTo(String value) {
            addCriterion("PAYMENT_REMARKS <>", value, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksGreaterThan(String value) {
            addCriterion("PAYMENT_REMARKS >", value, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("PAYMENT_REMARKS >=", value, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksLessThan(String value) {
            addCriterion("PAYMENT_REMARKS <", value, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksLessThanOrEqualTo(String value) {
            addCriterion("PAYMENT_REMARKS <=", value, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksLike(String value) {
            addCriterion("PAYMENT_REMARKS like", value, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksNotLike(String value) {
            addCriterion("PAYMENT_REMARKS not like", value, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksIn(List<String> values) {
            addCriterion("PAYMENT_REMARKS in", values, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksNotIn(List<String> values) {
            addCriterion("PAYMENT_REMARKS not in", values, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksBetween(String value1, String value2) {
            addCriterion("PAYMENT_REMARKS between", value1, value2, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andPaymentRemarksNotBetween(String value1, String value2) {
            addCriterion("PAYMENT_REMARKS not between", value1, value2, "paymentRemarks");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateIsNull() {
            addCriterion("FIRST_PRINT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateIsNotNull() {
            addCriterion("FIRST_PRINT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateEqualTo(Date value) {
            addCriterion("FIRST_PRINT_DATE =", value, "firstPrintDate");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateNotEqualTo(Date value) {
            addCriterion("FIRST_PRINT_DATE <>", value, "firstPrintDate");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateGreaterThan(Date value) {
            addCriterion("FIRST_PRINT_DATE >", value, "firstPrintDate");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateGreaterThanOrEqualTo(Date value) {
            addCriterion("FIRST_PRINT_DATE >=", value, "firstPrintDate");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateLessThan(Date value) {
            addCriterion("FIRST_PRINT_DATE <", value, "firstPrintDate");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateLessThanOrEqualTo(Date value) {
            addCriterion("FIRST_PRINT_DATE <=", value, "firstPrintDate");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateIn(List<Date> values) {
            addCriterion("FIRST_PRINT_DATE in", values, "firstPrintDate");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateNotIn(List<Date> values) {
            addCriterion("FIRST_PRINT_DATE not in", values, "firstPrintDate");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateBetween(Date value1, Date value2) {
            addCriterion("FIRST_PRINT_DATE between", value1, value2, "firstPrintDate");
            return (Criteria) this;
        }

        public Criteria andFirstPrintDateNotBetween(Date value1, Date value2) {
            addCriterion("FIRST_PRINT_DATE not between", value1, value2, "firstPrintDate");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByIsNull() {
            addCriterion("FIRST_PRINT_BY is null");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByIsNotNull() {
            addCriterion("FIRST_PRINT_BY is not null");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByEqualTo(String value) {
            addCriterion("FIRST_PRINT_BY =", value, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByNotEqualTo(String value) {
            addCriterion("FIRST_PRINT_BY <>", value, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByGreaterThan(String value) {
            addCriterion("FIRST_PRINT_BY >", value, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByGreaterThanOrEqualTo(String value) {
            addCriterion("FIRST_PRINT_BY >=", value, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByLessThan(String value) {
            addCriterion("FIRST_PRINT_BY <", value, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByLessThanOrEqualTo(String value) {
            addCriterion("FIRST_PRINT_BY <=", value, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByLike(String value) {
            addCriterion("FIRST_PRINT_BY like", value, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByNotLike(String value) {
            addCriterion("FIRST_PRINT_BY not like", value, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByIn(List<String> values) {
            addCriterion("FIRST_PRINT_BY in", values, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByNotIn(List<String> values) {
            addCriterion("FIRST_PRINT_BY not in", values, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByBetween(String value1, String value2) {
            addCriterion("FIRST_PRINT_BY between", value1, value2, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andFirstPrintByNotBetween(String value1, String value2) {
            addCriterion("FIRST_PRINT_BY not between", value1, value2, "firstPrintBy");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoIsNull() {
            addCriterion("PROVIDER_REFNO is null");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoIsNotNull() {
            addCriterion("PROVIDER_REFNO is not null");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoEqualTo(String value) {
            addCriterion("PROVIDER_REFNO =", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoNotEqualTo(String value) {
            addCriterion("PROVIDER_REFNO <>", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoGreaterThan(String value) {
            addCriterion("PROVIDER_REFNO >", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_REFNO >=", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoLessThan(String value) {
            addCriterion("PROVIDER_REFNO <", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_REFNO <=", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoLike(String value) {
            addCriterion("PROVIDER_REFNO like", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoNotLike(String value) {
            addCriterion("PROVIDER_REFNO not like", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoIn(List<String> values) {
            addCriterion("PROVIDER_REFNO in", values, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoNotIn(List<String> values) {
            addCriterion("PROVIDER_REFNO not in", values, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoBetween(String value1, String value2) {
            addCriterion("PROVIDER_REFNO between", value1, value2, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_REFNO not between", value1, value2, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andComputetatIsNull() {
            addCriterion("COMPUTETAT is null");
            return (Criteria) this;
        }

        public Criteria andComputetatIsNotNull() {
            addCriterion("COMPUTETAT is not null");
            return (Criteria) this;
        }

        public Criteria andComputetatEqualTo(String value) {
            addCriterion("COMPUTETAT =", value, "computetat");
            return (Criteria) this;
        }

        public Criteria andComputetatNotEqualTo(String value) {
            addCriterion("COMPUTETAT <>", value, "computetat");
            return (Criteria) this;
        }

        public Criteria andComputetatGreaterThan(String value) {
            addCriterion("COMPUTETAT >", value, "computetat");
            return (Criteria) this;
        }

        public Criteria andComputetatGreaterThanOrEqualTo(String value) {
            addCriterion("COMPUTETAT >=", value, "computetat");
            return (Criteria) this;
        }

        public Criteria andComputetatLessThan(String value) {
            addCriterion("COMPUTETAT <", value, "computetat");
            return (Criteria) this;
        }

        public Criteria andComputetatLessThanOrEqualTo(String value) {
            addCriterion("COMPUTETAT <=", value, "computetat");
            return (Criteria) this;
        }

        public Criteria andComputetatLike(String value) {
            addCriterion("COMPUTETAT like", value, "computetat");
            return (Criteria) this;
        }

        public Criteria andComputetatNotLike(String value) {
            addCriterion("COMPUTETAT not like", value, "computetat");
            return (Criteria) this;
        }

        public Criteria andComputetatIn(List<String> values) {
            addCriterion("COMPUTETAT in", values, "computetat");
            return (Criteria) this;
        }

        public Criteria andComputetatNotIn(List<String> values) {
            addCriterion("COMPUTETAT not in", values, "computetat");
            return (Criteria) this;
        }

        public Criteria andComputetatBetween(String value1, String value2) {
            addCriterion("COMPUTETAT between", value1, value2, "computetat");
            return (Criteria) this;
        }

        public Criteria andComputetatNotBetween(String value1, String value2) {
            addCriterion("COMPUTETAT not between", value1, value2, "computetat");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeIsNull() {
            addCriterion("CANCELLED_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeIsNotNull() {
            addCriterion("CANCELLED_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeEqualTo(String value) {
            addCriterion("CANCELLED_CODE =", value, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeNotEqualTo(String value) {
            addCriterion("CANCELLED_CODE <>", value, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeGreaterThan(String value) {
            addCriterion("CANCELLED_CODE >", value, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CANCELLED_CODE >=", value, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeLessThan(String value) {
            addCriterion("CANCELLED_CODE <", value, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeLessThanOrEqualTo(String value) {
            addCriterion("CANCELLED_CODE <=", value, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeLike(String value) {
            addCriterion("CANCELLED_CODE like", value, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeNotLike(String value) {
            addCriterion("CANCELLED_CODE not like", value, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeIn(List<String> values) {
            addCriterion("CANCELLED_CODE in", values, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeNotIn(List<String> values) {
            addCriterion("CANCELLED_CODE not in", values, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeBetween(String value1, String value2) {
            addCriterion("CANCELLED_CODE between", value1, value2, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledCodeNotBetween(String value1, String value2) {
            addCriterion("CANCELLED_CODE not between", value1, value2, "cancelledCode");
            return (Criteria) this;
        }

        public Criteria andCancelledRemIsNull() {
            addCriterion("CANCELLED_REM is null");
            return (Criteria) this;
        }

        public Criteria andCancelledRemIsNotNull() {
            addCriterion("CANCELLED_REM is not null");
            return (Criteria) this;
        }

        public Criteria andCancelledRemEqualTo(String value) {
            addCriterion("CANCELLED_REM =", value, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andCancelledRemNotEqualTo(String value) {
            addCriterion("CANCELLED_REM <>", value, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andCancelledRemGreaterThan(String value) {
            addCriterion("CANCELLED_REM >", value, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andCancelledRemGreaterThanOrEqualTo(String value) {
            addCriterion("CANCELLED_REM >=", value, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andCancelledRemLessThan(String value) {
            addCriterion("CANCELLED_REM <", value, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andCancelledRemLessThanOrEqualTo(String value) {
            addCriterion("CANCELLED_REM <=", value, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andCancelledRemLike(String value) {
            addCriterion("CANCELLED_REM like", value, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andCancelledRemNotLike(String value) {
            addCriterion("CANCELLED_REM not like", value, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andCancelledRemIn(List<String> values) {
            addCriterion("CANCELLED_REM in", values, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andCancelledRemNotIn(List<String> values) {
            addCriterion("CANCELLED_REM not in", values, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andCancelledRemBetween(String value1, String value2) {
            addCriterion("CANCELLED_REM between", value1, value2, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andCancelledRemNotBetween(String value1, String value2) {
            addCriterion("CANCELLED_REM not between", value1, value2, "cancelledRem");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgIsNull() {
            addCriterion("PAYOR_REMARKS_CATG is null");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgIsNotNull() {
            addCriterion("PAYOR_REMARKS_CATG is not null");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgEqualTo(String value) {
            addCriterion("PAYOR_REMARKS_CATG =", value, "payorRemarksCatg");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgNotEqualTo(String value) {
            addCriterion("PAYOR_REMARKS_CATG <>", value, "payorRemarksCatg");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgGreaterThan(String value) {
            addCriterion("PAYOR_REMARKS_CATG >", value, "payorRemarksCatg");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgGreaterThanOrEqualTo(String value) {
            addCriterion("PAYOR_REMARKS_CATG >=", value, "payorRemarksCatg");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgLessThan(String value) {
            addCriterion("PAYOR_REMARKS_CATG <", value, "payorRemarksCatg");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgLessThanOrEqualTo(String value) {
            addCriterion("PAYOR_REMARKS_CATG <=", value, "payorRemarksCatg");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgLike(String value) {
            addCriterion("PAYOR_REMARKS_CATG like", value, "payorRemarksCatg");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgNotLike(String value) {
            addCriterion("PAYOR_REMARKS_CATG not like", value, "payorRemarksCatg");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgIn(List<String> values) {
            addCriterion("PAYOR_REMARKS_CATG in", values, "payorRemarksCatg");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgNotIn(List<String> values) {
            addCriterion("PAYOR_REMARKS_CATG not in", values, "payorRemarksCatg");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgBetween(String value1, String value2) {
            addCriterion("PAYOR_REMARKS_CATG between", value1, value2, "payorRemarksCatg");
            return (Criteria) this;
        }

        public Criteria andPayorRemarksCatgNotBetween(String value1, String value2) {
            addCriterion("PAYOR_REMARKS_CATG not between", value1, value2, "payorRemarksCatg");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}